Release 10.1A: OpenEdge Data Management:
Database Administration

PROREST utility

Verifies the integrity of a database backup or restores a full or incremental backup of a database.

Syntax

prorest db-name device-name { -vp | -vf | -list }

Parameters

db-name

Specifies the database where you want to restore the backups.

device-name

Identifies the directory pathname of the input device (for example, a tape drive) or a standard file from which you are restoring the data. If device-name identifies a block or character special device, PROREST assumes the device has removable media, such as a tape or a floppy diskette.

-vp

Specifies that the restore utility reads the backup volumes and computes and compares the backup block cyclic redundancy checks (CRCs) with those in the block headers. To recover any data from a bad block, you must have specified a redundancy factor when you performed the database backup. See Chapter 5, "Backing Up a Database," for more information about error correction blocks and data recovery.

-vf

Specifies that the restore utility only compares the backup to the database block for block.

-list

Provides a description of all application data storage areas contained within a database backup. Use the information to create a new structure description file and database so you can restore the backup.

Notes

When restoring a backup, the target database must contain the same physical structure as the backup version. For example, it must have the same number of storage areas, records per block, and block size.
PROREST restores transaction log (TL) extents.
Before you restore a database, you might want to verify that your backup does not contain any corrupted blocks. You can use the PROREST utility to verify the integrity of a full or incremental backup of a database by using the Partial Verify or Full Verify parameters.
The Partial Verify or Full Verify parameters do not restore or alter the database. You must use the PROREST utility separately to restore the database.
You can use the Partial Verify parameter with both online and offline backups.
Use the Full Verify parameter immediately after performing an offline backup to verify that the backup is correct.
PROREST supports the use of internationalization startup parameters such as -cpinternal codepage and -cpstream codepage. See Chapter 18, "Database Startup Parameters," for a description of each database-related internationalization startup parameter.